use vudu

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[ConsultarUniversidadRol]
AS
BEGIN
	SET NOCOUNT ON;

    SELECT u.id_Universidad, u.nombre
	FROM Universidad u
	WHERE u.estadoRol = 'Inactivo';
END